/*
 Navicat Premium Data Transfer

 Source Server         : 121.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 80032
 Source Host           : localhost:3306
 Source Schema         : demo

 Target Server Type    : MySQL
 Target Server Version : 80032
 File Encoding         : 65001

 Date: 16/05/2023 09:18:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for base_menu
-- ----------------------------
DROP TABLE IF EXISTS `base_menu`;
CREATE TABLE `base_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(100) DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `menu_url` varchar(255) DEFAULT NULL,
  `parent_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统菜单表';

-- ----------------------------
-- Records of base_menu
-- ----------------------------
BEGIN;
INSERT INTO `base_menu` (`id`, `menu_name`, `create_time`, `update_time`, `menu_url`, `parent_id`) VALUES (1, '系统管理', NULL, NULL, NULL, NULL);
INSERT INTO `base_menu` (`id`, `menu_name`, `create_time`, `update_time`, `menu_url`, `parent_id`) VALUES (2, '菜单管理', '2023-04-03 11:12:13', '2023-04-03 11:12:13', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for base_user
-- ----------------------------
DROP TABLE IF EXISTS `base_user`;
CREATE TABLE `base_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_name` varchar(155) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `salt` varchar(64) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1643602335089381379 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of base_user
-- ----------------------------
BEGIN;
INSERT INTO `base_user` (`id`, `user_name`, `password`, `salt`, `create_time`, `update_time`, `icon`) VALUES (1, '2', '2', NULL, NULL, NULL, NULL);
INSERT INTO `base_user` (`id`, `user_name`, `password`, `salt`, `create_time`, `update_time`, `icon`) VALUES (1643601719407497217, 'lipeixin', '588e31621fd899716bc563786f0650df', 'aab0d0366d5b4c6b9a05fdf3820264b3', '2023-04-05 13:09:21', NULL, NULL);
INSERT INTO `base_user` (`id`, `user_name`, `password`, `salt`, `create_time`, `update_time`, `icon`) VALUES (1643602335089381378, '1', '23ae2716d9b00381f24ad8d107e8ac37', 'a2ef0d5373b64bb2b0284dc2a9e3323c', '2023-04-05 13:11:40', NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
